Diverse Lynx
PL-SQL Developer with ETL exp
Diverse Lynx, Atlanta, Georgia, United States, 30383
Position: PL-SQL Developer with ETL exp
Location: Atlanta, GA/Richmond, VA/Chicago, IL/Addison, TX
Job Description:Translate business requirements into technical specifications.Design and implement ETL (Informatica) process using SQL, ETL tool and Linux shell scripting to deliver high quality solutions.Strong data analysis, advance SQL query writing skill and resolving the defects by working across multiple teamsCollaborate with other development teams to manage interdependency, set up test cases, debug and maintain data quality.Ensure software stability via documentation, code reviews, regression, unit and user acceptance testing.Hands on logical and physical data modeling and database design responsibilities.Good understanding of Dimensional modelingBe able to lead and develop Informatica PowerCenter ETL complex flows connecting to heterogenous database such as oracle/MS SQL server.Develop complex oracle procedures ,functions, and packages to support database applications(API calls / DW reporting )Conduct both proactive and reactive performance tuning activities during course of development of new applications and existing legacy applications.Hands on experience to develop and support Unix Shell Scripting.Should have understanding of scheduler (Autosys)Perform data analysis and data profiling. Identify data quality issues.Primary Skills
InformaticaOracle SQL / PLSQLUNIX/SHELL SCRIPTSRequired Skills
Participate and guide team in estimating work necessary to realize a story/requirement through the delivery lifecycle.Contribute to story refinement/defining requirements.Perform spike/proof of concept as necessary to mitigate risk or implement new ideas.Code solutions and unit test to deliver a requirement/story per the defined acceptance criteria and compliance requirements.Utilize multiple architectural components (across data, application, business) in design and development of client requirements.Assist team with resolving technical complexities involved in realizing story work.Experience Informatica or other ETL toolProfessional experience with SQL/PLSQLUnderstand Data Federations, Data Lake, Data Mesh and Advance Cloud concepts.Experience automating ETL with job scheduling tools. Autosys PreferredExperience working with large data sets using big data solutions such as Hadoop, Spark etc. is a plusDemonstrate exceptional analytical skills and problem solving skills; excellent organizational, communication skillsA good team-player who seeks input and involves others in his/her communications; a person who values and cultivates relationships.An individual with a demonstrated ability to get things done and make things happen; a person who is resourceful, seizes opportunities and is an innovator.Desired Skills
Document and communicate required information for deployment, maintenance, support, and business functionality.Strong experience in Informatica, Dataware housing, data architecture, databases and writing/optimizing advanced SQL queries in a business environment with large-scale, complex datasetsContribute to existing test suites (integration, regression, performance),analyze test reports, identify any test issues/errors, and triage the underlying cause.Using Trino, Starburst or similar vendor tool exposure would be a plus.
Please advise if you would be interested in exploring this opportunity.Thanks & Regards,
Shashi Bhushan
Diverse Lynx LLC |300 Alexander Park|Suite #200|Princeton , NJ 08540
Office: +732-452-1006 ext:344
Email: shashi.bhushan@diverselynx.com | URL: http://www.diverselynx.com
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
Location: Atlanta, GA/Richmond, VA/Chicago, IL/Addison, TX
Job Description:Translate business requirements into technical specifications.Design and implement ETL (Informatica) process using SQL, ETL tool and Linux shell scripting to deliver high quality solutions.Strong data analysis, advance SQL query writing skill and resolving the defects by working across multiple teamsCollaborate with other development teams to manage interdependency, set up test cases, debug and maintain data quality.Ensure software stability via documentation, code reviews, regression, unit and user acceptance testing.Hands on logical and physical data modeling and database design responsibilities.Good understanding of Dimensional modelingBe able to lead and develop Informatica PowerCenter ETL complex flows connecting to heterogenous database such as oracle/MS SQL server.Develop complex oracle procedures ,functions, and packages to support database applications(API calls / DW reporting )Conduct both proactive and reactive performance tuning activities during course of development of new applications and existing legacy applications.Hands on experience to develop and support Unix Shell Scripting.Should have understanding of scheduler (Autosys)Perform data analysis and data profiling. Identify data quality issues.Primary Skills
InformaticaOracle SQL / PLSQLUNIX/SHELL SCRIPTSRequired Skills
Participate and guide team in estimating work necessary to realize a story/requirement through the delivery lifecycle.Contribute to story refinement/defining requirements.Perform spike/proof of concept as necessary to mitigate risk or implement new ideas.Code solutions and unit test to deliver a requirement/story per the defined acceptance criteria and compliance requirements.Utilize multiple architectural components (across data, application, business) in design and development of client requirements.Assist team with resolving technical complexities involved in realizing story work.Experience Informatica or other ETL toolProfessional experience with SQL/PLSQLUnderstand Data Federations, Data Lake, Data Mesh and Advance Cloud concepts.Experience automating ETL with job scheduling tools. Autosys PreferredExperience working with large data sets using big data solutions such as Hadoop, Spark etc. is a plusDemonstrate exceptional analytical skills and problem solving skills; excellent organizational, communication skillsA good team-player who seeks input and involves others in his/her communications; a person who values and cultivates relationships.An individual with a demonstrated ability to get things done and make things happen; a person who is resourceful, seizes opportunities and is an innovator.Desired Skills
Document and communicate required information for deployment, maintenance, support, and business functionality.Strong experience in Informatica, Dataware housing, data architecture, databases and writing/optimizing advanced SQL queries in a business environment with large-scale, complex datasetsContribute to existing test suites (integration, regression, performance),analyze test reports, identify any test issues/errors, and triage the underlying cause.Using Trino, Starburst or similar vendor tool exposure would be a plus.
Please advise if you would be interested in exploring this opportunity.Thanks & Regards,
Shashi Bhushan
Diverse Lynx LLC |300 Alexander Park|Suite #200|Princeton , NJ 08540
Office: +732-452-1006 ext:344
Email: shashi.bhushan@diverselynx.com | URL: http://www.diverselynx.com
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.