4C Solutions (India)

The Data analyst will ensure that the Data Architecture and Conceptual, Logical and Physical Data Models meet the client's business needs. The primary responsibility of the Data Analyst is translating the business requirements into logical and physical data models including on-going evolution of the logical data model in response to business analysts and developers requests. Responsible for designing and analyzing programs, processes, and procedures to extract, transform, integrate, and load data into data systems.

• Write queries and stored procedures based on client requirements
• Work with the Systems and Applications Architects to synchronize the data model with the application (object) model, and to define interfaces between various databases and systems and all the integration points.
• Ensure that the database queries and programs will give the end users the expected data, performance and quality characteristics.
• Respond to all data requests for information from the project team in a timely manner.
• Work with client to develop and test conversion and migration programs
• Design and develop new stored procedures or modify existing stored procedures to meet customer specific needs
• Analyze client data, develop mapping specifications, produce conversion samples, develop a production plan and lead the conversion process through deployment and production phases
• Analyzing data samples and identifying factors that affect conversion efforts and costs
• Generate/Create DB scripts and installation documents to be sent to clients along with application installations.
• Analyze, calculate, and recommend the initial data storage size and expected growth percentage/size.
• Analyze and recommend the database configuration in terms of indexes, table spaces, clusters and other database objects.
• Maintain communications with project team as well client's data team through various phases of the project.
• Gather data requirements, design reports, analyze the results, implement and test reports.
• Design and implement new reports and modify existing reports
• Support and maintain the Reporting and Data Analysis Tools used in the project
• Identify, troubleshoot, and close service requests for user data issues
• Measure, identify and optimize the queries, stored procedures and other data processes for better performance
• Create and maintain data transfer or synchronization jobs and processes
• Document data mapping , data dictionary, database schemas, entity relationships and data flows

• Bachelors and Masters degree in Computer Science or related areas
• Professional certifications from Database vendors like IBM, Oracle or Microsoft preferred
• Experience in all aspects of  data management methods and practices including data modeling, data profiling , data Mapping, design of data schemas, data Migration/conversion and data warehousing
• Experience in data analysis, conversion, and migration
• Proficiency in the design, development and management of relational databases
• Proficiency in the management and optimization of relational databases
• Experience in data modeling
• Experience with data analysis tools
• Experience with SQL Server, Oracle or DB2 databases
• Demonstrated knowledge in Relational database, data integrity and data relationship concepts
• Experience with ETL tools like Data Stage
• Experience with Data modeling tools like ERWin, Power Designer
• Experienced in working directly with customers and non-technical professionals