Blue.cloud
Associate Informatica / ETL Developer (India)
Blue.cloud, Chicago, Illinois, United States, 60290
Overview
We are looking for a candidate to provide
Informatica PowerCenter
development and production support, with 2 years of Informatica Center experience. Nice to have: Data Quality (IDQ), IICS, Control M, SSMS expertise to design and build the required solutions for our clients. Responsibilities
Independently plans, designs, develops, executes and monitors complex data integration activities to support project delivery and daily operation. Experience in defining, implementing, debugging and optimizing data integration mappings and scripts from a variety of data sources. Development of ETL code, metadata definition and models, queries, scripts, schedules, work processes and maintenance procedures; identify opportunities to optimize the sizing, performance and efficiency of existing processes. Perform unit testing, system integration testing, regression testing and assist with user acceptance testing. Consult with the business to develop documentation and communication materials to ensure accurate usage and interpretation of data. Develops technical understanding of how the data flows from various source systems to fine-tune data integration solutions. Work independently or as part of a team to deliver data warehouse ETL projects. Adhere to established standards and best practices and provide input for improvement of those processes. Self-motivated team player who can work with minimal supervision and adapt to a quickly changing environment. Maintain a high-volume data warehouse application. Ability to work on multiple tasks simultaneously and handle conflicting priorities. Experience and Education
At least 2+ years of relevant experience is desired. Bachelor's/Master's degree in Computer Science/Information Systems from a reputed university. Strong computer science fundamentals. Strong in communications with business stakeholders. Excellent technical, analytical and organizational skills. Effective written and verbal communication skills, including technical writing. Technical Skills & Competencies
Must have hands-on experience with commercial integration products including: PowerCenter 10.x (REQUIRED) Data Integration Hub (nice to have) PowerExchange (nice to have) Informatica Cloud (nice to have) Data Quality (nice to have) Go Anywhere (nice to have) Experience in Windows PowerShell / UNIX Shell Scripting, and Control-M to automate job runs.
Basic MSSQL Server Database development experience including:
Stored Procedures Explain Plans Constraints Views Materialized Views Export/Import Utilities
Must have strong knowledge of Software Development Life Cycle including requirement analysis, design, development, testing, and implementation. Hands-on experience in performance tuning of sources, targets, mappings and sessions. Azure Data Factory is a plus. Support
Ability to identify critical system health issues and flag them for discussion and resolution. Constantly questioning due to fluid processes and complexity of the environment. Proven experience in common support activities including
User Management Access management Object management (folder, connections, rules, etc.) Backing up repositories Code migration across multiple environments Performance diagnosis/improvement Ability to handle and coordinate Sev1 tickets
Maintaining standards
Proven experience in following standards and helping others adopt standards. Ensuring code is synced across all three environments. Ensuring development teams follow appropriate standards.
#J-18808-Ljbffr
We are looking for a candidate to provide
Informatica PowerCenter
development and production support, with 2 years of Informatica Center experience. Nice to have: Data Quality (IDQ), IICS, Control M, SSMS expertise to design and build the required solutions for our clients. Responsibilities
Independently plans, designs, develops, executes and monitors complex data integration activities to support project delivery and daily operation. Experience in defining, implementing, debugging and optimizing data integration mappings and scripts from a variety of data sources. Development of ETL code, metadata definition and models, queries, scripts, schedules, work processes and maintenance procedures; identify opportunities to optimize the sizing, performance and efficiency of existing processes. Perform unit testing, system integration testing, regression testing and assist with user acceptance testing. Consult with the business to develop documentation and communication materials to ensure accurate usage and interpretation of data. Develops technical understanding of how the data flows from various source systems to fine-tune data integration solutions. Work independently or as part of a team to deliver data warehouse ETL projects. Adhere to established standards and best practices and provide input for improvement of those processes. Self-motivated team player who can work with minimal supervision and adapt to a quickly changing environment. Maintain a high-volume data warehouse application. Ability to work on multiple tasks simultaneously and handle conflicting priorities. Experience and Education
At least 2+ years of relevant experience is desired. Bachelor's/Master's degree in Computer Science/Information Systems from a reputed university. Strong computer science fundamentals. Strong in communications with business stakeholders. Excellent technical, analytical and organizational skills. Effective written and verbal communication skills, including technical writing. Technical Skills & Competencies
Must have hands-on experience with commercial integration products including: PowerCenter 10.x (REQUIRED) Data Integration Hub (nice to have) PowerExchange (nice to have) Informatica Cloud (nice to have) Data Quality (nice to have) Go Anywhere (nice to have) Experience in Windows PowerShell / UNIX Shell Scripting, and Control-M to automate job runs.
Basic MSSQL Server Database development experience including:
Stored Procedures Explain Plans Constraints Views Materialized Views Export/Import Utilities
Must have strong knowledge of Software Development Life Cycle including requirement analysis, design, development, testing, and implementation. Hands-on experience in performance tuning of sources, targets, mappings and sessions. Azure Data Factory is a plus. Support
Ability to identify critical system health issues and flag them for discussion and resolution. Constantly questioning due to fluid processes and complexity of the environment. Proven experience in common support activities including
User Management Access management Object management (folder, connections, rules, etc.) Backing up repositories Code migration across multiple environments Performance diagnosis/improvement Ability to handle and coordinate Sev1 tickets
Maintaining standards
Proven experience in following standards and helping others adopt standards. Ensuring code is synced across all three environments. Ensuring development teams follow appropriate standards.
#J-18808-Ljbffr