SENIOR INFORMATICA DATA ENGINEER

Position Description.
Position Description At CGI, we’re a team of builders.
We call our employees members because all who join CGI are building their own company - one that has grown to professionals located in 40 countries.
Founded in , CGI is a leading IT and business process services firm committed to helping clients succeed.
We have the global resources, expertise, stability and dedicated professionals needed to achieve.
At CGI, we’re a team of builders.
We call our employees members because all who join CGI are building their own company - one that has grown to professionals located in 40 countries.
Founded in , CGI is a leading IT and business process services firm committed to helping clients succeed.
We have the global resources, expertise, stability and dedicated professionals needed to achieve results for our clients - and for our members.
Come grow with us.
Learn more at www.
gi.
om.
This is a great opportunity to join a winning team.
CGI offers a competitive compensation package with opportunities for growth and professional development.
Benefits for full-time, permanent members start on the first day of employment and include a paid time-off program and profit participation and stock purchase plans.
We wish to thank all applicants for their interest and effort in applying for this position, however, only candidates selected for interviews will be contacted.
No unsolicited agency referrals please.
Job Title.
Senior Informatica Data Engineer Position.
Senior Informatica Data Engineer Experience.
5 - 9 Years Category.
Software Development/ Engineering Main location.
Bangalore Position ID.
J Employment Type.
Full Time Your future duties and responsibilities.
Job Description.
----------------- Designs, develops, modifies, configures, debugs Informatica workflows using Informatica DEI and Informatica DEQ Performs migration of workflows from development/Test to production environment and provide post-deployment support Understanding and experience with managing meta data using Informatica ABC Tables Experience using parameter files, advanced transformations with Informatica Workflows/mappings Proficiency in working with Microsoft SQL Server and Microsoft SQL programming, database design, and query tuning.
TSQL.
Complex queries, stored procedures, views Experience in understanding and working with Hadoop cluster in a multi-tenant environment Experience with Big Data, Hadoop Stack and Proficient with HDFS, MR2, Hive, Sqoop, Spark and SQL.
Experience with on-prem and cloud versions of databases such as SQL Server.
Experience with Data migration from relational databases to Hadoop HDFS Load Hive and RDBMS/Microsoft SQL Server tables Hands on experience with UNIX and solid scripting skills - Develop, enhance and debug Unix Scripts Monitor and Support Informatica unix jobs in Control M Scheduling environment! Documents all technical specifications and associated project deliverables.
Ability to understand a process quickly and its purposes.
Experience with Agile delivery frameworks/methodologies (e.
.
Scrum, SAFe) and tools (i.
.
Jira, AzureDevOps).
Excellent verbal and written communication coupled with negotiation skills.
successfully juggle multiple, competing priorities and coordinate multiple tasks to ensure that work output is delivered on-time and accurately while operating in a fast-paced and rapidly evolving environment.
Understanding and experience with source code management, branching, merging using GitHub Experience.
----------- Must have 10+ years of IT Industry Must Have 8+ Years of experience in Development, Maintenance, Enhancement of ETL in a Data warehousing Environment.
Must have 6+ Years of experience in developing and deploying Informatica DEI and Informatica DEQ in UNIX and SQL Server/RDBMS environment Must have 2+ Hands-on years' experience working with Big Data/Hadoop Architecture Job Location.
Any CGI Office (BLR/Chennai/HYD/Mum) ------------ Skill set.
----------- Informatica DEI - MUST Informatica DEQ - MUST T-SQL Programming - Complex Queries, Stored Procedures, Views - MUST UNIX Scripting - MUST Understanding of Big Data and Experience with Hive - MUST Control-M Scheduler - MUST Azure DevOPS - MUST GITHUB - MUST Production Support on a shift basis - MUST Bachelor's degree/master's degree or related experience Experience in Analysis, Performance troubleshooting and Remediation of Data pipelines.
Experience with analyzing data, data modelling, data design, tuning and optimization.
Prior experience in insurance and/or reinsurance in support of specialty lines is a plus.
Professional Informatica certification is a plus.
This position requires sound technical skills, the ability to collaborate across teams both on-off shore, an operational / delivery mindset, and self-management leadership skills.
Ability to work in a demanding and fast-paced environment.
Ability to provide 24x7 production support on a scheduled rotational basis using Shifts.
Optional Skills.
-------------- Understanding and/or Experience with - Informatica Analyst, Informatica EDP, Informatica Address Doctor, Informatica MDM Understanding and/or Experience with - Databricks Understanding and/or experience with - Denodo Understanding and/or Experience with - Informatica IICS Skills.
GitHub P&C Insurance Unit Testing Unix Informatica What you can expect from us.
Insights you can act on While technology is at the heart of our clients’ digital transformation, we understand that people are at the heart of business success.
When you join CGI, you become a trusted advisor, collaborating with colleagues and clients to bring forward actionable insights that deliver meaningful and sustainable outcomes.
We call our employees “members” because they are CGI shareholders and owners, and, as owners, we enjoy working and growing together to build a company we are proud of.
This has been our Dream since , and it has brought us to where we are today—one of the world’s largest independent providers of IT and business consulting services.
At CGI, we recognize the richness that diversity brings.
We strive to create a work culture where everyone belongs, and we collaborate with clients in building more inclusive communities.
As an equal opportunity employer, we empower all our members to succeed and grow.
If you require an accommodation at any point during the recruitment process, please let us know.
We will be happy to assist.
Ready to become part of our success story? Join CGI—where your ideas and actions make a difference.