Data Engineer Python Etl & Plsql jobs at Citi Group in India, Pune

Responsibilities:

• Utilize knowledge of applications development procedures and concepts, and basic knowledge of other technical areas to identify and define necessary system enhancements, including using script tools and analyzing/interpreting code
• Consult with users, clients, and other technology groups on issues, and recommend programming solutions, install, and support customer exposure systems
• Apply fundamental knowledge of programming languages for design specifications.
• Analyze applications to identify vulnerabilities and security issues, as well as conduct testing and debugging
• Serve as advisor or coach to new or lower level analysts
• Identify problems, analyze information, and make evaluative judgements to recommend and implement solutions
• Resolve issues by identifying and selecting solutions through the applications of acquired technical experience and guided by precedents
• Has the ability to operate with a limited level of direct supervision.
• Can exercise independence of judgement and autonomy.
• Acts as SME to senior stakeholders and /or other team members.
• Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.

Qualifications:

• 5-7 years of relevant experience in design development using ETL Tools - AB-Initio / MS SQL Server Technology
• Must have worked on Various Ab-Initio Products like EME/Express-IT and Experience in Continuous Flows.
• Must be Familiar with ETL Concepts and good on Implementing them .
• Knowledge of NoSQLDatabases/Hadoop-Hive,Spark will be added advantage
• Experience in systems analysis and programming of software applications
• Experience in managing and implementing successful projects
• Working knowledge of consulting/project management techniques/methods
• Ability to work under pressure and manage deadlines or unexpected changes in expectations or requirements

Education:

• Bachelor’s degree/University degree or equivalent experience

This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.

Time Type:

The Data Science Senior Analyst is a seasoned professional role. Applies in-depth disciplinary knowledge, contributing to the development of new techniques and the improvement of processes and work-flow for the area or function. Integrates subject matter and industry expertise within a defined area. Requires in-depth understanding of how areas collectively integrate within the sub-function as well as coordinate and contribute to the objectives of the function and overall business. Evaluates moderately complex and variable issues with substantial potential impact, where development of an approach/taking of an action involves weighing various alternatives and balancing potentially conflicting situations using multiple sources of information. Requires good analytical skills in order to filter, prioritize and validate potentially complex and dynamic material from multiple sources. Strong communication and diplomacy skills are required. Regularly assumes informal/formal leadership role within teams. Involved in coaching and training of new recruits. Significant impact in terms of project size, geography, etc. by influencing decisions through advice, counsel and/or facilitating services to others in area of specialization. Work and performance of all teams in the area are directly affected by the performance of the individual.Responsibilities:

• Conducts strategic data analysis, identifies insights and implications and make strategic recommendations, develops data displays that clearly communicate complex analysis.
• Mines and analyzes data from various banking platforms to drive optimization and improve data quality.
• Deliver analytics initiatives to address business problems with the ability to determine data required, assess time & effort required and establish a project plan.
• Consults with business clients to determine system functional specifications. Applies comprehensive understanding of how multiple areas collectively integrate to contribute towards achieving business objectives.
• Consults with users and clients to solve complex system issues/problems through in-depth evaluation of business processes, systems and industry standards; recommends solutions.
• Leads system change process from requirements through implementation; provides user and operational support of application to business users.
• Formulates and defines systems scope and objectives for complex projects through research and fact-finding combined with an understanding of applicable business systems and industry standards.
• Impacts the business directly by ensuring the quality of work provided by self and others; impacts own team and closely related work teams.
• Considers the business implications of the application of technology to the current business environment; identifies and communicates risks and impacts.
• Drives communication between business leaders and IT; exhibits sound and comprehensive communication and diplomacy skills to exchange complex information.
• Performs other duties and functions as assigned.
• Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.

Qualifications:

• 5-8 years experience in business and data analysis, process improvement and project management
• Ability to effectively use complex analytical, interpretive and problem solving techniques.
• Demonstrated interpersonal, verbal and written communication skills.
• Methodical attention to detail
• Experience using tools for statistical modeling of large data sets

Education:

• Bachelors (4 Year University) Degree or equivalent experience required

This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.

Anticipated Posting Close Date:

Responsibilities:

- Develop and maintain application development to complicated enterprise data lineage

- Optimize industry based tool to simplify enterprise level data complexity via data lineage

- Debug and resolve graph-related issues

- Conduct code reviews for quality assurance

- Write and maintain documentation for functionalities and APIs

- Integrate and validate third-party libraries and tools

- Manage source code using version control systems

- Implement algorithms for code generation and optimization

- Perform code refactoring for better maintainability and efficiency

- Stay updated with advancements in Data lineage technology

- Profile and benchmark compiler performance on various platforms

- Develop automated testing and verification of code base and functionality

- Analyze performance metrics to identify areas for improvement

- Participate in design and architecture discussions

- Use static and dynamic analysis tools to improve code quality

- Research new techniques and methodologies

- Contribute to and engage with open-source compiler projects

Qualifications:

• Strong understanding of Data Lineage, metadata management and reference data development and data analytics.
• Good knowledge about relational databases like Oracle, SQL / PLSQL,
• Strong knowledge in one or more of the areas of: Data lineage, application development, python or Java coding experience
• Hands on experience of any coding language and tool based configuration prior experience.
• Full Software Development Kit (SDK) development cycle experience.
• Pragmatic problem-solving and ability to work independently or as part of a team.
• Proficiency in ab-initio mHub or python programming languages.
• Proficiency with 1 or more of the following programming languages: Java, API, Python
• 2+ years of non-internship professional software development experience
• A passion for development, strong work ethic, and continuous learning.
• Experience with code optimization techniques for different hardware architectures.

Education:

• Bachelor’s degree/University degree or equivalent experience

This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.

Preferred Qualifications:

- Bachelor's in computer science or related field.

- Experience relational database i.e. SQL / PLSQL, Oracle etc

- Experience with code development, metadata management, reference data, Lineage tool

- Experience with developing data lineage using tool or custom code.

- Experience in Data management and coding language

- At least 4+ years of application Ab-initio Metadata hub development experience.

and engage with open-source compiler projects

Time Type:

Responsibilities:

• Supports initiatives related to User Acceptance Testing (UAT) process and product rollout into production. Testing specialists who work with technology project managers, UAT professionals and users to design and implement appropriate scripts/plans for an application testing strategy/approach.
• Conducts a variety of moderately complex process monitoring, product evaluation and audit assignments; reports issues and makes recommendations for solutions.
• Ensures project standards and procedures exist, are fully clearly documented and followed throughout the software development life cycle; makes recommendations for enhanced documentation.
• Monitors products for conformance to standards; monitors processes for conformance to procedures.
• Documents findings and performs preliminary root causes analyses to provide recommended improvements.
• Ensures all corrective actions are assigned, documented and completed.
• Verifies traceability in project work products.
• Gathers, maintains and creates reports on quality metrics.
• Exhibits good understanding of procedures and concepts within own technical area and a basic knowledge of these elements in other areas.
• Requires basic understanding of how own area integrates within IT Quality to achieve objectives.
• Makes evaluative judgments based on the analysis of factual information; resolves problems by identifying and selecting solutions through the application of acquired technical experience and guided by precedents.
• Directly impacts the business by ensuring the quality of work provided by self and others; impacts own team and closely related work teams.
• Provides informal guidance to new team members.
• Performs other duties and functions as assigned.
• Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.

Qualifications:

• 5-8 years Quality Assurance (QA) experience in BFSI Domain and should be an expertise in ETL testing & DB-related testing.
• Understanding of ETL requirements (source-to-target mappings) and Test automation experience is huge plus
• Writing basic SQLs to check record counts, data truncation, invalid data types, NULLs and data integrity, data transformation, aggregate functions testing
• Knowledge of Database objects and relational data model and experience in data validation & data analysis.
• Experience in requirement reviews & able to identify, communicate and document discrepancies
• Understanding of QA within the Software Development Lifecycle (SDLC) and QA methodologies
• Understanding of Quality Processes
• Demonstrated logical analysis skills, attention to detail and problem solving Proven ability to work to deadlines.
• Consistently demonstrates clear and concise written and verbal communication skills
• QA Experience in defining, designing & executing test cases

• Bachelor’s/University degree or equivalent experience

Time Type:

We are looking for a Full stack core software engineer with deep understanding of Java/Python and its ecosystems, and strong hands-on experience in building high-performing, scalable, enterprise-grade applications. You will be part of a talented software team that works on mission-critical applications.

As a full stack core software engineer, your responsibilities include understanding user requirements and working with a development team on the design, implementation and deliver of Java/Python application while providing expertise in the full software development lifecycle, from concept and design to testing.

Qualifications:

• 8 to 12 years of industry experience, with a strong hands-on experience in the hands-on development of mission-critical applications using Java/Python technologies, aligning each project with the firm's strategic objectives, and overseeing team operations to ensure project success.
• Experience with complex system integration projects.
• Java, Spring, Spring Boot, Spring Cloud, J2EE Design Patterns, REST services.
• Front End Technologies like JavaScript and Angular version, CSS2/CSS3, HTML
• Strong Knowledge of SQL, JDBC, Unix commands.
• Hands-on Database experience in relational (Oracle/DB2) and No-SQL (MongoDB).
• Hands-on experience on working / deploying application on Cloud.
• Hands-on experience in code testing tools like Junit / Mockito / Cucumber.
• Deployment Acquaintance in Apache Tomcat, Open shift or other cloud environments.
• Expertise in Test driven development (Junit, JMeter), Continuous Integration (Jenkins), Build tool (Maven) and Version Control (Git), Development tools (Eclipse, IntelliJ).
• Excellent communication skills (written and verbal), ability to work in a team environment.
• Excellent analytical and problem-solving skills and the ability to work well independently.
• Experience working with business analysts, database administrators, project managers and technical architects in multiple geographical areas.
• Experience in the Financial Services industry is added advantage. Understanding Financial and Reporting Hierarchies will be beneficial.

Required Skills:

• Minimum 8 to 12 years of application development experience in Java with: Spring Boot & Microservices; REST Web Services; JPA with hibernate; Core Java.
• Minimum 3+ years of Hands-on experience in designing architecture for enterprise applications.
• Angular and Java Script
• Experience in working on a native cloud platform.
• Experience with development IDEs such as Eclipse and IntelliJ
• Experience with SQL/NONSQL such as Oracle, PostgreSQL, Neo4j, and MongoDB
• Experience with caching framework such as Redis.
• Experience with CI/CD systems such as helm and harness.
• Experience with messaging services such as Kafka.
• Experience in Python, Unix shell scripting will be an added plus
• Excellent trouble shooting skills.
• Strong problem-solving skills, business acumen, and demonstrated excellent oral and written communication skills with both technical and non-technical audiences.
• Experience with Agile Software Development Lifecycle methodology and related tooling. For example -JIRA, Scrum.

:

• Bachelor’s or equivalent degree in Computer Science

Time Type:

Responsibilities:

• Utilize knowledge of applications development procedures and concepts, and basic knowledge of other technical areas to identify and define necessary system enhancements, including using script tools and analyzing/interpreting code
• Consult with users, clients, and other technology groups on issues, and recommend programming solutions, install, and support customer exposure systems
• Apply fundamental knowledge of programming languages for design specifications.
• Analyze applications to identify vulnerabilities and security issues, as well as conduct testing and debugging
• Serve as advisor or coach to new or lower level analysts
• Identify problems, analyze information, and make evaluative judgements to recommend and implement solutions
• Resolve issues by identifying and selecting solutions through the applications of acquired technical experience and guided by precedents
• Has the ability to operate with a limited level of direct supervision.
• Can exercise independence of judgement and autonomy.
• Acts as SME to senior stakeholders and /or other team members.
• Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.

Qualifications:

• 5-7 years of relevant experience in design development using ETL Tools - AB-Initio / MS SQL Server Technology
• Must have worked on Various Ab-Initio Products like EME/Express-IT and Experience in Continuous Flows.
• Must be Familiar with ETL Concepts and good on Implementing them .
• Knowledge of NoSQLDatabases/Hadoop-Hive,Spark will be added advantage
• Experience in systems analysis and programming of software applications
• Experience in managing and implementing successful projects
• Working knowledge of consulting/project management techniques/methods
• Ability to work under pressure and manage deadlines or unexpected changes in expectations or requirements

Education:

• Bachelor’s degree/University degree or equivalent experience

This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.

Time Type:

Key Responsibilities:

• Work as Java Team lead for suite of applications In Internal Audit
• Should own the responsibility of a module and synergize with team to deliver.
• Should be able to lead a team to deliver complex system designs.
• Understand requirements and code and unit test required components
• Support acceptance tests and production test
• Report progress on work and work collaboratively with the existing global team
• Keep abreast of latest technological happenings in his work area and bring relevant ideas/concept to the table

Development Value:

(What opportunities to develop can the job offer a prospective candidate?)

• Excellent opportunity to learn Compliance function and opportunity to work on integrated platform for GRC.
• Opportunity to learn/ add domain skill in the area of Governance, Risk and Compliance.
• Opportunity to directly work for one of the best technology teams on Wall Street.

Skills:

• Expertise in Core java and Java ETL .
• Solid understanding of SOA concepts, RESTful API design.
• Strong OOP fundamentals, programming languages, and web frameworks.
• Knowledge of cloud computing and deployment strategies using virtual environments
• Knowledge in ETL tool like Starburst, SprintBatch, Ab Initio
• Ability to prioritize and manage schedules under tight, fixed deadlines
• Ability to produce professional, technically sound, and visually appealing presentations and architecture designs.
• Strong writing, communication, time-management, decision-making, and basic task organization skills
• Experience creating high-level technical/process documentation and presentations for audiences at various levels. Experience writing/editing technical, business, and process documentation in an Information Technology/Engineering environment
• Must have worked on Oracle RDBMS. Should be good at data models and have an understanding of relational database systems.
• Must be able to understand requirements & convert to technical design and code
• Knowledge of source code control systems, unit test framework, build and deployment tools
• Experienced with large-scale programs rollout and ability to create and maintain details WBS project plans.
• Must be able to work independently as well as in a team environment. Must be able to adapt to a rapidly changing environment.
• Python, copilot knowledge is a bonus

Bachelor’s degree in Computer Science, Information Systems Management, or related field preferred

Knowledge/Experience:

• 8 to 11 years of strong experience in Java/J2EE, Spring, Hibernate with expertise in design, development, performance tuning, troubleshooting and deployment
• Strong knowledge of microservices and eco-system
• Working knowledge of Containerization using Docker/Kubernetes
• Good understanding of tomcat, and Linux or UNIX operating systems.
• Should be well versed with solutions with latest tech advancements.
• Familiar with standard SDLC and Agile processes.
• Hands on working experience and ability to motivate and lead the team

Time Type: